home *** CD-ROM | disk | FTP | other *** search
/ Internet.Works 40 / Issue 40.iso / pc / Tutorial / Database / dbdrilldown_Detail.cfm < prev    next >
Encoding:
Text File  |  2000-11-07  |  1.1 KB  |  52 lines
  1. <!--- Query returning detail information for selected item --->
  2. <CFQUERY name="Detail" dataSource="hotel">
  3.     SELECT hotels.HotelName AS DetailField1, hotels.Address AS DetailField2, hotels.StarRating AS DetailField3, hotels.Amenities AS DetailField4, hotels.City AS DetailField5
  4.     FROM hotels
  5.     WHERE hotels.HotelID = #URL.ID#
  6. </CFQUERY>
  7.  
  8.  
  9. <HTML><HEAD>
  10.     <TITLE>db drilldown - Detail</TITLE>
  11. </HEAD><BODY bgcolor="ffffff">
  12.  
  13.  
  14. <FONT size="+1">db drilldown</FONT> <BR>
  15. <FONT size="+2"><B>Detail</B></FONT>
  16.  
  17. <P>
  18.  
  19. <TABLE>
  20.  
  21. <CFOUTPUT query="Detail">
  22.  
  23. <TR>
  24.     <TD valign=top><B>HotelName:</B></TD>
  25.     <TD valign=top>#DetailField1#</TD>
  26.     </TR>
  27. <TR>
  28.     <TD valign=top><B>Address:</B></TD>
  29.     <TD valign=top>#DetailField2#</TD>
  30.     </TR>
  31. <TR>
  32.     <TD valign=top><B>StarRating:</B></TD>
  33.     <TD valign=top>#DetailField3#</TD>
  34.     </TR>
  35. <TR>
  36.     <TD valign=top><B>Amenities:</B></TD>
  37.     <TD valign=top>#DetailField4#</TD>
  38.     </TR>
  39. <TR>
  40.     <TD valign=top><B>City:</B></TD>
  41.     <TD valign=top>#DetailField5#</TD>
  42.     </TR>
  43.  
  44.  
  45. <TR><TD colspan=5><HR></TD></TR>
  46. </CFOUTPUT>
  47.  
  48. </TABLE>
  49.  
  50.  
  51. </BODY></HTML>
  52.